CREATE PROCEDURE [dbo].[ProviderClinicTypeDelete]
	@ProviderId		UNIQUEIDENTIFIER,
	@ClinicTypeId	UNIQUEIDENTIFIER
AS

DELETE 
FROM	ProviderClinicType
WHERE	NOT(@ProviderId IS NULL AND @ClinicTypeId IS NULL)
	AND (@ProviderId IS NULL OR ProviderId = @ProviderId)
	AND (@ClinicTypeId IS NULL OR ClinicTypeId = @ClinicTypeId)
	
RETURN @@ROWCOUNT 